﻿/*
	AnOtherBlog 0.1 to 0.2 SQL Server 2005 Schema

	2008-07-03, Julio, Ajustes varios
					aob_Pages: agrega Slugs
					aob_Posts: suprime Raters y Rating
					aob_Comments: cambia el nombre CommentContent

*/


ALTER TABLE [dbo].[aob_Pages]
ADD [Slug] nvarchar(255) NULL
GO

ALTER TABLE [dbo].[aob_Posts]
DROP COLUMN [Raters]
GO
ALTER TABLE [dbo].[aob_Posts]
DROP COLUMN [Rating]
GO

/* Esta vez no hace falta salvar el contenido */
ALTER TABLE [dbo].[aob_PostComment]
ADD [CommentContent] nvarchar(max) NULL
GO
ALTER TABLE [dbo].[aob_PostComment]
DROP COLUMN [Comment]
GO

